CREATE TABLE [dbo].[TTTIFN_BANC]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_TIPO_FINA] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NO_CONT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_SUBR] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IM_SALD_INIC] [numeric] (16, 4) NULL CONSTRAINT [DF__TTTIFN_BA__IM_SA__7405149D] DEFAULT ((0)),
[PO_INTR] [numeric] (9, 4) NULL CONSTRAINT [DF__TTTIFN_BA__PO_IN__74F938D6] DEFAULT ((0)),
[PO_FINA] [numeric] (9, 4) NULL CONSTRAINT [DF__TTTIFN_BA__PO_FI__75ED5D0F] DEFAULT ((0)),
[PO_EXCE] [numeric] (9, 4) NULL CONSTRAINT [DF__TTTIFN_BA__PO_EX__76E18148] DEFAULT ((0)),
[IM_LINE_CRED] [numeric] (16, 4) NULL CONSTRAINT [DF__TTTIFN_BA__IM_LI__77D5A581] DEFAULT ((0)),
[IM_PAGO_FINA] [numeric] (16, 4) NULL CONSTRAINT [DF__TTTIFN_BA__IM_PA__78C9C9BA] DEFAULT ((0)),
[IM_INGR_FINA] [numeric] (16, 4) NULL CONSTRAINT [DF__TTTIFN_BA__IM_IN__79BDEDF3] DEFAULT ((0)),
[TI_SITU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_MONE_CRED] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_DIAS_FINA] [int] NULL CONSTRAINT [DF__TTTIFN_BA__NU_DI__7AB2122C] DEFAULT ((0)),
[ST_LIBO] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TTTIFN_BA__ST_LI__7BA63665] DEFAULT ('N'),
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIFN_BA__CO_US__7C9A5A9E] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TTTIFN_BA__FE_US__7D8E7ED7] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIFN_BA__CO_US__7E82A310] DEFAULT (suser_sname()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TTTIFN_BA__FE_US__7F76C749] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIFN_BANC] ADD CONSTRAINT [PK__TTTIFN_B__E34C6F3D18B7765F] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_BANC], [CO_TIPO_FINA]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIFN_BANC] ADD CONSTRAINT [FK__TTTIFN_BA__CO_EM__72E6D332] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
